Skip to main content

Connect Salesforce to OPNBI

  • By using this document user will know how to connect Salesforce to OPNBI.

  • Salesforce integration is the process of merging the data and functionality of Salesforce with another application to provide users with a single unified experience.

Objective

  • Connect Salesforce to OPNBI.

Usecase

  • Salesforce allows users to fetch data from salesforce & integrate it with your company application. For example; in this document, we will fetch the data from salesforce & integrate it with OPNBI.

Steps to Connect Salesforce to OPNBI

1. Salesforce

  • Salesforce provides the powerful source of the API which helps in developing and customizing your data.
  1. log in to your Salesforce developer edition.

  2. Follow the given links to know how to set up your salesforce login.

  3. User needs to Create the Connected App first.

Note
  • Follow this link to see how to create the connected app.
  1. While creating the Connected App fill below details:
  • Connected App Name: Opnbi
  • API Name: Opnbi (it will be filled automatically)
  • Contact Email: Your email address
  • Enable OAuth Settings: Check the checkbox
  • Set callback URL: https://na11.salesforce.com/ConnectTest/oauth/_callback
  • Selected OAuth Settings: Manage user data via APIs (API)

Docusaurus Slash Introduction

Docusaurus Slash Introduction

  1. Scroll down & click on the Save button. It will ask you for permission.

  2. Click on Continue button & your connected app is created.

    Docusaurus Slash Introduction

  3. User can copy & paste Consumer Key, Consumer Secret & Callback URL to a notepad for further use.

  • How to get Security Token?
  1. By following this link use can generate the Security Token.

  2. Reset your security token & save it in a notepad for further use.

Note
  • Click on this link to download the project files.

2. Eclipse

  1. Import the downloaded project into the Eclipse.

  2. Open java project file & new.properties file.

  3. User needs to place the required jar file into the project. (Jar files are included in the downloaded project zip file)

  4. User needs to fill the below details in the new.properties file:

  • loginInstanceDomain=login.salesforce.com
  • apiVersion='your salesforce api version'
  • userName='your salesforce login username'
  • password='your salesforce login password+security token'
  • consumerKey='your consumer key'
  • consumerSecret='your consumer secret'
  • grantType=password
  1. Save your project file.

  2. Export the project jar file & give a name exds.

3. OPNBI

  • OPNBI is a Business Intelligence application for both personal and business use.
  1. Place that project jar file in the OPNBI\tomcat\webapps\opnbi\WEB-INF\lib folder.

  2. Start your server & launch OPNBI.

  3. Go to hamburger menu Docusaurus Slash Introduction --> datasource.

  4. Click on Create from the bottom-most toolbar.

    Docusaurus Slash Introduction

  5. Find Custom from the search box:

    Docusaurus Slash Introduction

  6. Click on Custom & fill in the details as shown:

    Docusaurus Slash Introduction

  7. Click on the TEST CONNECTION button & one message is shown for Connection Successful.

    Docusaurus Slash Introduction

  8. Click on the OK & SAVE button & Go to the Datasource section in OPNBI.

  9. Select created Datasource & click on Create Dataset from the bottom-most toolbar.

  10. Give your dataset the name s_contacts.

  11. In Additional Info users need to paste their query. (User can get the sample query from the readme file available in the project zip file)

    Docusaurus Slash Introduction

  12. Click on the PREVIEW button & data of contacts is shown.

    Docusaurus Slash Introduction

  13. Click on SUBMIT button & your dataset is created.

  14. To know how to create dashboard using this dataset follow this link.